package com.sxyc.weixin.controller;

import java.io.BufferedReader;
import java.io.DataOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.jfinal.core.Controller;
import com.jfinal.kit.LogKit;
import com.jfinal.kit.PropKit;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;




public class JuheController extends Controller {
	
	public static final String DEF_CHATSET = "UTF-8";
    public static final int DEF_CONN_TIMEOUT = 30000;
    public static final int DEF_READ_TIMEOUT = 30000;
    public static String userAgent =  "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36";
 
    //配置您申请的KEY
    public static final String APPKEY =PropKit.get("appKey");
    
    /**
     * 调用聚合接口获取支持违章查询的城市，及参数要求
     * 解析Json信息并保存更新
     */
    @SuppressWarnings("rawtypes")
	public static void updateCitys() {
    	JSONObject data = getRequest1();
    	Collection colls = data.values();
    	Iterator it = colls.iterator();
    	while(it.hasNext()){
    		JSONObject province = (JSONObject) it.next();//省
	    	JSONArray citys= province.getJSONArray("citys");
    		for (Object object : citys) {
				System.out.println(object);
    	    	JSONObject city = JSON.parseObject( object.toString());//市
    	    	Record juhe = Db.findFirst("select id from juhe where city_code = '"+city.get("city_code")+"'");
    	    	if(juhe == null){
    	    		System.out.println("save() "+city.get("city_name"));
    	    		juhe = new Record().set("Province", province.get("province")).set("Province_code", province.get("province_code"))
        	    			.set("City", city.get("city_name")).set("City_code", city.get("city_code")).set("Abbr", city.get("abbr"))
        	    			.set("Engine", city.get("engine")).set("Engineno", city.get("engineno")).set("Classa", city.get("classa"))
        	    			.set("Classno", city.get("classno")).set("Regist", city.get("regist")).set("Registno", city.get("registno"));
        	    	Db.save("juhe", juhe);
    	    	}else{
    	    		System.out.println("update() "+city.get("city_name"));
    	    		juhe.set("Province", province.get("province")).set("Province_code", province.get("province_code"))
			    			.set("City", city.get("city_name")).set("City_code", city.get("city_code")).set("Abbr", city.get("abbr"))
			    			.set("Engine", city.get("engine")).set("Engineno", city.get("engineno")).set("Classa", city.get("classa"))
        	    			.set("Classno", city.get("classno")).set("Regist", city.get("regist")).set("Registno", city.get("registno"));
        	    	Db.update("juhe", juhe);
    	    	}
			}
    	}
    	System.out.println("聚合数据更新完成！");
    }
    
    //1.获取支持城市参数接口
    @SuppressWarnings({ "rawtypes", "unchecked" })
	public static JSONObject getRequest1(){
        String result =null;
        String url ="http://v.juhe.cn/wz/citys";//请求接口地址
        Map params = new HashMap();//请求参数
            params.put("province","");//默认全部，省份简写，如：ZJ、JS
            params.put("dtype","");//返回数据格式：json或xml或jsonp,默认json
            params.put("format","");//格式选择1或2，默认1
            params.put("callback","");//返回格式选择jsonp时，必须传递
            params.put("key",APPKEY);//你申请的key
            System.out.println("APPKEY--->"+APPKEY);
            
            
 
        try {
            result =net(url, params, "GET");
            
            JSONObject object = JSON.parseObject(result);
            if(object.getInteger("error_code")==0){
//                System.out.println(object.get("result"));
                return (JSONObject) object.get("result");
            }else{
                System.out.println(object.get("error_code")+":"+object.get("reason"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
		return null;
    }
    
    //2.请求违章查询接口
    @SuppressWarnings({ "rawtypes", "unchecked" })
    public JSONObject getRequest2(String city, String hphm, String engineno, String classa){
    	LogKit.warn(" city :"+city+"  hphm :"+hphm+"  engineno :"+engineno+"  classa :"+classa);
        String result =null;
        String url ="http://v.juhe.cn/wz/query";//请求接口地址
        Map params = new HashMap();//请求参数
            params.put("dtype","");//返回数据格式：json或xml或jsonp,默认json
            params.put("callback","");//返回格式选择jsonp时，必须传递
            params.put("key",APPKEY);//你申请的key
            params.put("city", city);//城市代码 *
            params.put("hphm", hphm);//号牌号码 完整7位 ,需要utf8 urlencode*
            params.put("hpzl","");//号牌类型，默认02
            params.put("engineno", engineno);//发动机号 (根据城市接口中的参数填写)
            params.put("classno", classa);//车架号 (根据城市接口中的参数填写)
            JSONObject object = null;
            try {
				result =net(url, params, "GET");
				object = JSON.parseObject(result);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				LogKit.warn("违章查询异常！");
			}
//        	result = HttpUtils.get(url+"?"+urlencode(params));
            return object;
    }
    
  //3.接口剩余请求次数查询
    @SuppressWarnings({ "rawtypes", "unchecked" })
	public static void getRequest3(){
        String result =null;
        String url ="http://v.juhe.cn/wz/status";//请求接口地址
        Map params = new HashMap();//请求参数
            params.put("key",APPKEY);//应用APPKEY(应用详细页查询)
            params.put("dtype","");//返回数据的格式,xml或json，默认json
 
        try {
            result =net(url, params, "GET");
            JSONObject object = JSON.parseObject(result);
            if(object.getInteger("error_code")==0){
                System.out.println(object.get("result"));
            }else{
                System.out.println(object.get("error_code")+":"+object.get("reason"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
 
    /**
     *
     * @param strUrl 请求地址
     * @param params 请求参数
     * @param method 请求方法
     * @return  网络请求字符串
     * @throws Exception
     */
    @SuppressWarnings({ "rawtypes", "unchecked" })
    public static String net(String strUrl, Map params,String method) throws Exception {
        HttpURLConnection conn = null;
        BufferedReader reader = null;
        String rs = null;
        try {
            StringBuffer sb = new StringBuffer();
            if(method==null || method.equals("GET")){
                strUrl = strUrl+"?"+urlencode(params);
            }
            URL url = new URL(strUrl);
            conn = (HttpURLConnection) url.openConnection();
            if(method==null || method.equals("GET")){
                conn.setRequestMethod("GET");
            }else{
                conn.setRequestMethod("POST");
                conn.setDoOutput(true);
            }
            conn.setRequestProperty("User-agent", userAgent);
            conn.setUseCaches(false);
            conn.setConnectTimeout(DEF_CONN_TIMEOUT);
            conn.setReadTimeout(DEF_READ_TIMEOUT);
            conn.setInstanceFollowRedirects(false);
            conn.connect();
            if (params!= null && method.equals("POST")) {
                try {
                    DataOutputStream out = new DataOutputStream(conn.getOutputStream());
                        out.writeBytes(urlencode(params));
                } catch (Exception e) {
                    // TODO: handle exception
                }
            }
            InputStream is = conn.getInputStream();
            reader = new BufferedReader(new InputStreamReader(is, DEF_CHATSET));
            String strRead = null;
            while ((strRead = reader.readLine()) != null) {
                sb.append(strRead);
            }
            rs = sb.toString();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (reader != null) {
                reader.close();
            }
            if (conn != null) {
                conn.disconnect();
            }
        }
        return rs;
    }
 
    //将map型转为请求参数型
    @SuppressWarnings("rawtypes")
	public static String urlencode(Map<String,Object>data) {
        StringBuilder sb = new StringBuilder();
        for (Map.Entry i : data.entrySet()) {
            try {
                sb.append(i.getKey()).append("=").append(URLEncoder.encode(i.getValue()+"","UTF-8")).append("&");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }
        }
        return sb.toString();
    }
    
}